﻿CREATE TABLE [dbo].[UserReceiptInfo] (
    [UserReceiptID]   BIGINT         IDENTITY (10001, 1) NOT NULL,
    [UserID]          BIGINT         NOT NULL,
    [Consignee]       NVARCHAR (20)  NOT NULL,
    [ProvID]          INT            NULL,
    [CityID]          INT            NULL,
    [CountyID]        INT            NULL,
    [SpecificAddress] NVARCHAR (200) NULL,
    [FullAddress]     NVARCHAR (300) NOT NULL,
    [Phone]           VARCHAR (50)   NOT NULL,
    [PostalCode]      VARCHAR (10)   NULL,
    [Default]         BIT            NULL,
    [Tag]             NVARCHAR (10)  NULL,
    CONSTRAINT [PK_USERRECEIPTINFO] PRIMARY KEY CLUSTERED ([UserReceiptID] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'标签', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'Tag';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是默认地址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'Default';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'邮政编码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'PostalCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'联系电话', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'Phone';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'完整地址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'FullAddress';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'详细地址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'SpecificAddress';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'县/区标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'CountyID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'市标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'CityID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'省标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'ProvID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'收货人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'Consignee';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'UserID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户收货标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo', @level2type = N'COLUMN', @level2name = N'UserReceiptID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户收货信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'UserReceiptInfo';

